package ssau.knyazev.db.common;

public class FrameworkSettings {
	
	public static final String DB_URL = "jdbc:oracle:thin:@localhost:1521:XE";
    public static final String DB_USER = "swora";
    public static final String DB_PASSWORD = "svora";

	public static final String MODEL_TABLE = "table";
	public static final String MODEL_ALL_DATA_QUERY = "all";
	public static final String MODEL_DELETE_DATA_QUERY = "delete";
	public static final String MODEL_INSERT_DATA_QUERY = "insert";
	public static final String MODEL_UPDATE_DATA_QUERY = "update";
	public static final String MODEL_TABLE_STRUCTURE = "structure";
	public static final String MODEL_FIELD = "field";
	public static final String MODEL_FIELD_NAME = "name";
	public static final String MODEL_FIELD_FK = "fk";
	public static final String MODEL_FIELD_DEFAULT_VALUE = "default";
	public static final String MODEL_TABLE_FRAME = "frame";
	
	public static final String TABLE_META = "meta";
	public static final String TABLE_ROW = "row";
	public static final String TABLE_DATA = "data";
	public static final String TABLE_RECORD = "record"; 
		
	public static final String LIST_KEY = "key";
	public static final String LIST_VALUE = "value";
	
	public static final String LOGIN_DB_ADMIN = "dbAdmin";
	public static final String LOGIN_STAFF = "staff";
	public static final String LOGIN_IMPORT = "import";
	public static final String LOGIN_QUERY = "select cu.user_id, cu.name, cr.name " +
			"from cafe_users cu, cafe_roles cr " +
			"where login = ? and password = ? and cu.role_id = cr.role_id";

}
